﻿CREATE TABLE [flcr].[ACCT_LEDGER] (
    [ACCT_LEDGER_ID]    INT           NOT NULL,
    [AUDIT_USER]        VARCHAR (100) NOT NULL,
    [AUDIT_DTTM]        DATETIME      NOT NULL,
    [AUDIT_DTTM_TZ]     INT           NOT NULL,
    [AUDIT_MOD_USER]    VARCHAR (100) NOT NULL,
    [AUDIT_MOD_DTTM]    DATETIME      NOT NULL,
    [AUDIT_MOD_DTTM_TZ] INT           NOT NULL,
    [ACCT_FY_ID]        INT           NOT NULL,
    [ACCT_ACCOUNT_ID]   INT           NOT NULL,
    [ACCT_BUDGET_ID]    INT           NOT NULL,
    [TRANS_DT]          DATE          NOT NULL,
    [AMOUNT]            DECIMAL (18)  NOT NULL,
    [CURRENCY_TYPE]     INT           NOT NULL,
    [CONTRACT_ID]       INT           NOT NULL,
    [SUPPLIER_ID]       INT           NOT NULL,
    [MODULE_ACTIVE_FLG] BIT           NOT NULL,
    [MODULE_ID]         INT           NOT NULL,
    [MODULE_SYSTEM_ID]  VARCHAR (MAX) NOT NULL,
    [MEMO]              VARCHAR (MAX) NULL
);

